if exists(select * from sys.columns where Name = N'SyndicateId' and Object_ID = Object_ID(N'glcontact') and system_type_id = 231 and max_length = 510 )    
begin
	alter table glcontact DROP COLUMN SyndicateId 
end

GO
if not exists(select * from sys.columns where Name = N'SyndicateId' and Object_ID = Object_ID(N'glcontact'))
begin
	alter table glcontact
	add SyndicateId udtSyndicate
end
